INSERT INTO pais VALUES (1,'Uruguay');
INSERT INTO pais VALUES (2,'Argentina');
INSERT INTO pais VALUES (3,'Brasil');


INSERT INTO ciudad VALUES (1,'Montevideo',1);
INSERT INTO ciudad VALUES (2,'Punta Del Este',1);
INSERT INTO ciudad VALUES (3,'Rio De Janeiro',3);


INSERT INTO hotel VALUES (11111, 'Hotel Radisson Victoria Plaza',1);
INSERT INTO hotel VALUES (22222, 'Hotel Sheraton Montevideo',1);
INSERT INTO hotel VALUES (33333, 'Hotel Four Points Montevideo',1);
INSERT INTO hotel VALUES (44444, 'Hotel Conrad',2);
INSERT INTO hotel VALUES (55555, 'Atlantico Boutique Hotel',2);
INSERT INTO hotel VALUES (66666, 'Barradas Parque Hotel & Spa',2);
INSERT INTO hotel VALUES (77777, 'Golden Beach Resort and Spa',2);
INSERT INTO hotel VALUES (14325, 'Copacabana Palace Hotel',3);


INSERT INTO tipohab VALUES (14325, 'SNG');
INSERT INTO tipohab VALUES (14325, 'DBL');
INSERT INTO tipohab VALUES (14325, 'LUX');
INSERT INTO tipohab VALUES (14325, 'BRK');
INSERT INTO tipohab VALUES (11111, 'SNG');
INSERT INTO tipohab VALUES (11111, 'DBL');
INSERT INTO tipohab VALUES (11111, 'BRK');
INSERT INTO tipohab VALUES (33333, 'SNG');
INSERT INTO tipohab VALUES (33333, 'DBL');
INSERT INTO tipohab VALUES (33333, 'LUX');
INSERT INTO tipohab VALUES (44444, 'SNG');
INSERT INTO tipohab VALUES (44444, 'DBL');
INSERT INTO tipohab VALUES (55555, 'SNG');



INSERT INTO habitacion VALUES (11111,1,'SNG',1);
INSERT INTO habitacion VALUES (11111,2,'DBL',2);
INSERT INTO habitacion VALUES (11111,3,'DBL',2);
INSERT INTO habitacion VALUES (11111,4,'DBL',2);
INSERT INTO habitacion VALUES (11111,100,'BRK',99);
INSERT INTO habitacion VALUES (11111,200,'BRK',99);
INSERT INTO habitacion VALUES (14325,1,'SNG',1);
INSERT INTO habitacion VALUES (14325,2,'DBL',2);
INSERT INTO habitacion VALUES (14325,3,'DBL',2);
INSERT INTO habitacion VALUES (14325,4,'DBL',2);
INSERT INTO habitacion VALUES (14325,5,'LUX',4);
INSERT INTO habitacion VALUES (14325,1000,'BRK',98);
INSERT INTO habitacion VALUES (14325,2000,'BRK',98);
INSERT INTO habitacion VALUES (33333,1,'SNG',1);
INSERT INTO habitacion VALUES (33333,2,'LUX',4);
INSERT INTO habitacion VALUES (33333,3,'DBL',4);
INSERT INTO habitacion VALUES (33333,4,'DBL',4);
INSERT INTO habitacion VALUES (44444,1,'SNG',1);
INSERT INTO habitacion VALUES (44444,2,'DBL',1);
INSERT INTO habitacion VALUES (55555,1,'SNG',1);





INSERT INTO usohab VALUES (11111,1,'2017-10-01',0);
INSERT INTO usohab VALUES (11111,1,'2017-10-02',0);
INSERT INTO usohab VALUES (11111,1,'2017-10-03',1);
INSERT INTO usohab VALUES (11111,1,'2017-10-04',1);
INSERT INTO usohab VALUES (11111,1,'2017-10-05',0);
INSERT INTO usohab VALUES (11111,1,'2017-10-06',0);
INSERT INTO usohab VALUES (11111,1,'2017-10-07',0);
INSERT INTO usohab VALUES (11111,1,'2017-10-08',0);
INSERT INTO usohab VALUES (11111,2,'2017-10-01',0);
INSERT INTO usohab VALUES (11111,2,'2017-10-02',0);
INSERT INTO usohab VALUES (11111,2,'2017-10-03',1);
INSERT INTO usohab VALUES (11111,2,'2017-10-04',0);
INSERT INTO usohab VALUES (11111,2,'2017-10-05',0);
INSERT INTO usohab VALUES (11111,2,'2017-10-06',0);
INSERT INTO usohab VALUES (11111,2,'2017-10-07',0);
INSERT INTO usohab VALUES (11111,2,'2017-10-08',0);
INSERT INTO usohab VALUES (11111,3,'2017-10-01',0);
INSERT INTO usohab VALUES (11111,3,'2017-10-02',0);
INSERT INTO usohab VALUES (11111,3,'2017-10-03',1);
INSERT INTO usohab VALUES (11111,3,'2017-10-04',0);
INSERT INTO usohab VALUES (11111,3,'2017-10-05',0);
INSERT INTO usohab VALUES (11111,3,'2017-10-06',0);
INSERT INTO usohab VALUES (11111,3,'2017-10-07',0);
INSERT INTO usohab VALUES (11111,3,'2017-10-08',0);
INSERT INTO usohab VALUES (11111,4,'2017-10-01',0);
INSERT INTO usohab VALUES (11111,4,'2017-10-02',0);
INSERT INTO usohab VALUES (11111,4,'2017-10-03',1);
INSERT INTO usohab VALUES (11111,4,'2017-10-04',0);
INSERT INTO usohab VALUES (11111,4,'2017-10-05',0);
INSERT INTO usohab VALUES (11111,4,'2017-10-06',0);
INSERT INTO usohab VALUES (11111,4,'2017-10-07',0);
INSERT INTO usohab VALUES (11111,4,'2017-10-08',0);
INSERT INTO usohab VALUES (11111,100,'2017-10-01',0);
INSERT INTO usohab VALUES (11111,100,'2017-10-02',0);
INSERT INTO usohab VALUES (11111,100,'2017-10-03',1);
INSERT INTO usohab VALUES (11111,100,'2017-10-04',0);
INSERT INTO usohab VALUES (11111,100,'2017-10-05',0);
INSERT INTO usohab VALUES (11111,100,'2017-10-06',0);
INSERT INTO usohab VALUES (11111,100,'2017-10-07',0);
INSERT INTO usohab VALUES (11111,100,'2017-10-08',0);
INSERT INTO usohab VALUES (11111,200,'2017-10-01',0);
INSERT INTO usohab VALUES (11111,200,'2017-10-02',0);
INSERT INTO usohab VALUES (11111,200,'2017-10-03',1);
INSERT INTO usohab VALUES (11111,200,'2017-10-04',0);
INSERT INTO usohab VALUES (11111,200,'2017-10-05',0);
INSERT INTO usohab VALUES (11111,200,'2017-10-06',0);
INSERT INTO usohab VALUES (11111,200,'2017-10-07',0);
INSERT INTO usohab VALUES (11111,200,'2017-10-08',0);
INSERT INTO usohab VALUES (33333,1,'2017-10-01',0);
INSERT INTO usohab VALUES (33333,1,'2017-10-02',0);
INSERT INTO usohab VALUES (33333,1,'2017-10-03',1);
INSERT INTO usohab VALUES (33333,1,'2017-10-04',1);
INSERT INTO usohab VALUES (33333,1,'2017-10-05',0);
INSERT INTO usohab VALUES (33333,1,'2017-10-06',0);
INSERT INTO usohab VALUES (33333,1,'2017-10-07',0);
INSERT INTO usohab VALUES (33333,1,'2017-10-08',0);
INSERT INTO usohab VALUES (33333,2,'2017-10-01',0);
INSERT INTO usohab VALUES (33333,2,'2017-10-02',0);
INSERT INTO usohab VALUES (33333,2,'2017-10-03',1);
INSERT INTO usohab VALUES (33333,2,'2017-10-04',0);
INSERT INTO usohab VALUES (33333,2,'2017-10-05',0);
INSERT INTO usohab VALUES (33333,2,'2017-10-06',0);
INSERT INTO usohab VALUES (33333,2,'2017-10-07',0);
INSERT INTO usohab VALUES (33333,2,'2017-10-08',0);
INSERT INTO usohab VALUES (33333,3,'2017-10-01',0);
INSERT INTO usohab VALUES (33333,3,'2017-10-02',0);
INSERT INTO usohab VALUES (33333,3,'2017-10-03',1);
INSERT INTO usohab VALUES (33333,3,'2017-10-04',0);
INSERT INTO usohab VALUES (33333,3,'2017-10-05',0);
INSERT INTO usohab VALUES (33333,3,'2017-10-06',0);
INSERT INTO usohab VALUES (33333,3,'2017-10-07',0);
INSERT INTO usohab VALUES (33333,3,'2017-10-08',0);
INSERT INTO usohab VALUES (33333,4,'2017-10-01',0);
INSERT INTO usohab VALUES (33333,4,'2017-10-02',0);
INSERT INTO usohab VALUES (33333,4,'2017-10-03',1);
INSERT INTO usohab VALUES (33333,4,'2017-10-04',0);
INSERT INTO usohab VALUES (33333,4,'2017-10-05',0);
INSERT INTO usohab VALUES (33333,4,'2017-10-06',0);
INSERT INTO usohab VALUES (33333,4,'2017-10-07',0);
INSERT INTO usohab VALUES (33333,4,'2017-10-08',0);
INSERT INTO usohab VALUES (14325,1,'2017-10-01',0);
INSERT INTO usohab VALUES (14325,1,'2017-10-02',0);
INSERT INTO usohab VALUES (14325,1,'2017-10-03',1);
INSERT INTO usohab VALUES (14325,1,'2017-10-04',1);
INSERT INTO usohab VALUES (14325,1,'2017-10-05',0);
INSERT INTO usohab VALUES (14325,1,'2017-10-06',0);
INSERT INTO usohab VALUES (14325,1,'2017-10-07',0);
INSERT INTO usohab VALUES (14325,1,'2017-10-08',0);
INSERT INTO usohab VALUES (14325,2,'2017-10-01',0);
INSERT INTO usohab VALUES (14325,2,'2017-10-02',0);
INSERT INTO usohab VALUES (14325,2,'2017-10-03',1);
INSERT INTO usohab VALUES (14325,2,'2017-10-04',0);
INSERT INTO usohab VALUES (14325,2,'2017-10-05',0);
INSERT INTO usohab VALUES (14325,2,'2017-10-06',0);
INSERT INTO usohab VALUES (14325,2,'2017-10-07',0);
INSERT INTO usohab VALUES (14325,2,'2017-10-08',0);
INSERT INTO usohab VALUES (14325,3,'2017-10-01',0);
INSERT INTO usohab VALUES (14325,3,'2017-10-02',0);
INSERT INTO usohab VALUES (14325,3,'2017-10-03',1);
INSERT INTO usohab VALUES (14325,3,'2017-10-04',0);
INSERT INTO usohab VALUES (14325,3,'2017-10-05',0);
INSERT INTO usohab VALUES (14325,3,'2017-10-06',0);
INSERT INTO usohab VALUES (14325,3,'2017-10-07',0);
INSERT INTO usohab VALUES (14325,3,'2017-10-08',0);
INSERT INTO usohab VALUES (14325,4,'2017-10-01',0);
INSERT INTO usohab VALUES (14325,4,'2017-10-02',0);
INSERT INTO usohab VALUES (14325,4,'2017-10-03',1);
INSERT INTO usohab VALUES (14325,4,'2017-10-04',0);
INSERT INTO usohab VALUES (14325,4,'2017-10-05',0);
INSERT INTO usohab VALUES (14325,4,'2017-10-06',0);
INSERT INTO usohab VALUES (14325,4,'2017-10-07',0);
INSERT INTO usohab VALUES (14325,4,'2017-10-08',0);
INSERT INTO usohab VALUES (14325,5,'2017-10-01',0);
INSERT INTO usohab VALUES (14325,5,'2017-10-02',0);
INSERT INTO usohab VALUES (14325,5,'2017-10-03',1);
INSERT INTO usohab VALUES (14325,5,'2017-10-04',0);
INSERT INTO usohab VALUES (14325,5,'2017-10-05',0);
INSERT INTO usohab VALUES (14325,5,'2017-10-06',0);
INSERT INTO usohab VALUES (14325,5,'2017-10-07',0);
INSERT INTO usohab VALUES (14325,5,'2017-10-08',0);
INSERT INTO usohab VALUES (14325,1000,'2017-10-01',0);
INSERT INTO usohab VALUES (14325,1000,'2017-10-02',0);
INSERT INTO usohab VALUES (14325,1000,'2017-10-03',1);
INSERT INTO usohab VALUES (14325,1000,'2017-10-04',0);
INSERT INTO usohab VALUES (14325,1000,'2017-10-05',0);
INSERT INTO usohab VALUES (14325,1000,'2017-10-06',0);
INSERT INTO usohab VALUES (14325,1000,'2017-10-07',0);
INSERT INTO usohab VALUES (14325,1000,'2017-10-08',0);
INSERT INTO usohab VALUES (14325,2000,'2017-10-01',0);
INSERT INTO usohab VALUES (14325,2000,'2017-10-02',0);
INSERT INTO usohab VALUES (14325,2000,'2017-10-03',1);
INSERT INTO usohab VALUES (14325,2000,'2017-10-04',0);
INSERT INTO usohab VALUES (14325,2000,'2017-10-05',0);
INSERT INTO usohab VALUES (14325,2000,'2017-10-06',0);
INSERT INTO usohab VALUES (14325,2000,'2017-10-07',0);
INSERT INTO usohab VALUES (14325,2000,'2017-10-08',0);



INSERT INTO usuario VALUES ('PCuevas@gmail.com','pwdPC');
INSERT INTO usuario VALUES ('usr2@gmail.com','pwd1');
INSERT INTO usuario VALUES ('usr3@gmail.com','pwd3');
INSERT INTO usuario VALUES ('usr4@gmail.com','pwd4');
INSERT INTO usuario VALUES ('usr5@gmail.com','pwd5');
INSERT INTO usuario VALUES ('usr6@gmail.com','pwd6');
INSERT INTO usuario VALUES ('usr7@gmail.com','pwd7');





INSERT INTO regimen VALUES ('SA','Solo Alojamiento');
INSERT INTO regimen VALUES ('AD','Alojamiento y Desayuno');
INSERT INTO regimen VALUES ('MP','Media Pensi?n');
INSERT INTO regimen VALUES ('PC','Pensi?n Completa');
INSERT INTO regimen VALUES ('TI','Todo Inclu?do');



INSERT INTO reserva VALUES ('PCuevas@gmail.com',14325,1,1,'MP','2014-12-31','2015-02-01','2015-02-15');
INSERT INTO reserva VALUES ('PCuevas@gmail.com',14325,1,1,'MP','2015-12-31','2016-02-01','2016-03-15');
INSERT INTO reserva VALUES ('PCuevas@gmail.com',14325,1,1,'MP','2016-10-31','2017-02-01','2016-02-17');
INSERT INTO reserva VALUES ('PCuevas@gmail.com',55555,1,1,'MP','2014-12-31','2015-01-01','2015-01-15');
INSERT INTO reserva VALUES ('PCuevas@gmail.com',55555,1,1,'MP','2015-12-31','2016-01-01','2016-01-15');
INSERT INTO reserva VALUES ('PCuevas@gmail.com',55555,1,1,'MP','2016-10-31','2017-01-01','2016-01-17');
INSERT INTO reserva VALUES ('usr7@gmail.com',44444,2,2,'PC','2014-12-31','2015-01-01','2015-01-15');
INSERT INTO reserva VALUES ('usr7@gmail.com',44444,2,2,'PC','2015-12-31','2016-01-01','2016-01-15');
INSERT INTO reserva VALUES ('usr7@gmail.com',44444,2,2,'PC','2016-10-31','2017-01-01','2016-01-17');




INSERT INTO huesped VALUES (123456789012,'Huesped','Uno','Dos', 1, 12345678, 'UHuesped@hotmail.com',99123456)
INSERT INTO huesped VALUES (234567890123,'Huesped','Dos','Tres', 1, 23456789, 'DHuesped@Gmail.com',99234567)



INSERT INTO prepago VALUES ('PCuevas@gmail.com',14325,1,'MP','2014-12-31','2015-02-01','2015-02-15');
INSERT INTO prepago VALUES ('PCuevas@gmail.com',14325,1,'MP','2015-12-31','2016-02-01','2016-03-15');
INSERT INTO prepago VALUES ('PCuevas@gmail.com',14325,1,'MP','2016-10-31','2017-02-01','2016-02-17');
INSERT INTO prepago VALUES ('PCuevas@gmail.com',44444,1,'MP','2014-12-31','2015-01-01','2015-01-15');
INSERT INTO prepago VALUES ('PCuevas@gmail.com',44444,1,'MP','2015-10-31','2016-11-21','2016-11-21');
INSERT INTO prepago VALUES ('PCuevas@gmail.com',44444,1,'MP','2016-10-31','2017-11-23','2016-11-23');
INSERT INTO prepago VALUES ('usr7@gmail.com',44444,1,'PC','2014-12-31','2015-01-01','2015-01-15');
INSERT INTO prepago VALUES ('usr7@gmail.com',44444,1,'PC','2015-12-31','2016-01-01','2016-01-15');
INSERT INTO prepago VALUES ('usr7@gmail.com',44444,2,'PC','2016-10-31','2017-01-01','2016-01-17');
INSERT INTO prepago VALUES ('usr7@gmail.com',44444,1,'MP','2015-10-31','2016-11-21','2016-11-21');
INSERT INTO prepago VALUES ('usr7@gmail.com',44444,1,'MP','2016-10-31','2017-11-23','2016-11-23');
INSERT INTO prepago VALUES ('usr7@gmail.com',14325,1,'MP','2015-10-31','2016-11-21','2016-11-21');
INSERT INTO prepago VALUES ('usr7@gmail.com',14325,1,'MP','2016-10-31','2016-11-23','2016-11-23');


INSERT INTO prephues VALUES (5,123456789012);
INSERT INTO prephues VALUES (6,234567890123);
INSERT INTO prephues VALUES (12,123456789012);
INSERT INTO prephues VALUES (13,234567890123);
